But in DB2, you must provide a value for NOT NULL columns in an INSERT statement when a default hasn't been defined. 但在DB2中,如果未定义该值,则必须在INSERT语句中为NOTNULL列提供值。
In MySQL, if you try to execute an INSERT statement that does not provide a value for a NOT NULL column, the command is successful. 在MySQL中,如果要执行一个不提供NOTNULL列值的INSERT语句,此命令没有问题。
Note that when using OLAP data sources, you will not be able to use null in the else statement, and will need to use a static value. 注意,在使用OLAP数据源时,不能在else语句中使用null,需要使用一个静态值。
Note that the test for null values is gone from the FOR statement, because you want to handle that condition by writing a diagnostic record. 注意,对null值的检查从FOR语句中消失了,因为希望通过写诊断记录来处理这种情况。
If the condition evaluates to FALSE or NULL, the loop is bypassed, and control passes to the next statement. 如果条件的求值结果为FALSE或NULL,那么将绕过循环,并且控制被传递给下一条语句。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement. 空指示符值在执行SQLUPDATE语句之前通过RPGHANDLEUPDATE子过程设置。
So in the example above, the NOT NULL constraint would get violated, and the INSERT statement would error out. 因此,在上面的示例中,会违反NOTNULL约束,INSERT语句会出错。
The null indicator values are populated during the execution of the SQL FETCH statement. 空指示符值在SQLFETCH语句执行过程中填充。
Also, the IF statement has been inverted: you now test for null coordinates ( instead of NOT NULL)), write a log record if found, and proceed with the insert otherwise. 另外,IF语句已经反转了,现在检查null坐标(而不是NOTNULL),如果找到了,就写日志记录,否则就继续处理插入。
The report author replies back with the statement that only null suppression is required on both columns and rows. 报表创建者回复说,在行和列上都仅需要nullsuppression。
Enter a comment to negate the if ( largestCityPopulationSB== null) statement by adding two forward-slash marks://. 通过添加两个斜杠标记,输入注释取消(largestCityPopulationSB==null)判断语句://。
If the local column's null property is not identical to the remote column's null property, a warning message is issued, but the statement is not aborted. 如果本地列的null属性与远程列的null属性不同,则会发出警告信息,但语句不中止。